package com.ckf.login_wx.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ckf.login_wx.entity.User;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface UserMapper extends BaseMapper<User> {

	@Select("select * from myuser where ${likename} like concat('%',#{name},'%')")
	public List<User> selectlike(@Param("name") String name,@Param("likename") String likename);

	
	//@Select("CREATE TABLE student(id INT PRIMARY KEY AUTO_INCREMENT COMMENT '学号',name VARCHAR(200) COMMENT '姓名',age int COMMENT '年龄') COMMENT='学生信息'")
	@Select("${name}")
	public void jian(@Param("name") String name);
}
